<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title></title>
			<link rel="stylesheet" href="media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
						<a name="top"></a>
<h2>[MySQLTableReport] element index</h2>
	<h3>Package indexes</h3>
	<ul>
						<li><a href="elementindex_default.html">default</a></li>
					<li><a href="elementindex_QueryTableParser.html">QueryTableParser</a></li>
					<li><a href="elementindex_Loader.html">Loader</a></li>
					<li><a href="elementindex_Anemometer.html">Anemometer</a></li>
					<li><a href="elementindex_QueryExplain.html">QueryExplain</a></li>
					<li><a href="elementindex_AnemometerModel.html">AnemometerModel</a></li>
			</ul>
<a href="elementindex.html">All elements</a>
<br />
<div class="index-letter-menu">
	<a class="index-letter" href="elementindex_MySQLTableReport.html#c">c</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#d">d</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#e">e</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#f">f</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#g">g</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#h">h</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#j">j</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#l">l</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#m">m</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#n">n</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#o">o</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#p">p</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#q">q</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#r">r</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#s">s</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#w">w</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#_">_</a>
</div>

	<a name="_"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">_</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">__construct</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#method__construct">MySQLTableReport::__construct()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">create a new instance, pass configuration information describing the datasource  and the report tables and fields.</div>
					</dd>
		</dl>
	<a name="c"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">c</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">clear</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodclear">MySQLTableReport::clear()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">Remove blank strings as values in form fields.</div>
					</dd>
		</dl>
	<a name="d"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">d</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">date_range</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methoddate_range">MySQLTableReport::date_range()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">look for a range of date values for the given column, and return  values to be added to the WHERE clause</div>
					</dd>
		</dl>
	<a name="e"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">e</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">execute</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodexecute">MySQLTableReport::execute()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">Execute the generated query on the configured databse and return  a result handle</div>
					</dd>
		</dl>
	<a name="f"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">f</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">from</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodfrom">MySQLTableReport::from()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">define the primary table to select from</div>
					</dd>
		</dl>
	<a name="g"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">g</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">ge</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodge">MySQLTableReport::ge()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">apply a &quot;greater than or equal to&quot; operator to a WHERE condition, instead  of the default equality matching</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_column_names</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_column_names">MySQLTableReport::get_column_names()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">retuns a list of all column names.  These will be exactly the same as  the columns returned by the query.</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_custom_fields</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_custom_fields">MySQLTableReport::get_custom_fields()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">returns a list of custom fields names.</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_distinct_values</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_distinct_values">MySQLTableReport::get_distinct_values()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">given a table and column, find all the unique values.  This is a utility  method often used when building dropdown lists on a search form, or getting  values for pivot operations.</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_form_fields</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_form_fields">MySQLTableReport::get_form_fields()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">return the list of form fields defined by the configuration parameters used   to construct this object.  Field names are prefixed by the table *alias*</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_form_field_values</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_form_field_values">MySQLTableReport::get_form_field_values()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">return an associate array with form_field_name =&gt; value for all fields.</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_pivot_values</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_pivot_values">MySQLTableReport::get_pivot_values()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">return the list of values for a given pivot column</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_search_uri</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_search_uri">MySQLTableReport::get_search_uri()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">return a urlencoded string of parameters that were used in this report.</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_tables</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_tables">MySQLTableReport::get_tables()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">returns the list of table names, not the aliases</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_table_by_alias</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_table_by_alias">MySQLTableReport::get_table_by_alias()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">gets the concrete name of a table for the given alias</div>
					</dd>
			<dt class="field">
						<span class="method-title">get_table_fields</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodget_table_fields">MySQLTableReport::get_table_fields()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">select the field names for the report tables from the database.</div>
					</dd>
			<dt class="field">
						<span class="method-title">group</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodgroup">MySQLTableReport::group()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">set the GROUP BY expression</div>
					</dd>
			<dt class="field">
						<span class="method-title">gt</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodgt">MySQLTableReport::gt()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">greater than: see documentation for ge()</div>
					</dd>
		</dl>
	<a name="h"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">h</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">having</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodhaving">MySQLTableReport::having()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">set the HAVING clause</div>
					</dd>
		</dl>
	<a name="j"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">j</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">join</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodjoin">MySQLTableReport::join()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">add a table to the JOIN clause</div>
					</dd>
		</dl>
	<a name="l"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">l</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">le</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodle">MySQLTableReport::le()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">less than or equal to: see documentation for ge()</div>
					</dd>
			<dt class="field">
						<span class="method-title">like</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodlike">MySQLTableReport::like()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">like: see documentation for ge()</div>
					</dd>
			<dt class="field">
						<span class="method-title">limit</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodlimit">MySQLTableReport::limit()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">set the LIMIT clause</div>
					</dd>
			<dt class="field">
						<span class="method-title">lt</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodlt">MySQLTableReport::lt()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">less than: see documentation for ge()</div>
					</dd>
		</dl>
	<a name="m"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">m</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						MySQLTableReport
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html">MySQLTableReport</a> in MySQLTableReport.php</div>
							<div class="index-item-description">class MySQLTableReport  Generic reporting class.  Given a configuration file, that describes the tables  and fields to be searched, and information to connect to a database, take form data  and generate an SQL query to run.</div>
					</dd>
			<dt class="field">
						<span class="include-title">MySQLTableReport.php</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/_MySQLTableReport.php.html">MySQLTableReport.php</a> in MySQLTableReport.php</div>
					</dd>
		</dl>
	<a name="n"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">n</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">ne</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodne">MySQLTableReport::ne()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">not equals: see documentation for ge()</div>
					</dd>
		</dl>
	<a name="o"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">o</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">order</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodorder">MySQLTableReport::order()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">set the ORDER BY clause</div>
					</dd>
		</dl>
	<a name="p"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">p</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">pivot</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodpivot">MySQLTableReport::pivot()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">preform a pivot on a column.  Get the unique list of values</div>
					</dd>
			<dt class="field">
						<span class="method-title">process_form_data</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodprocess_form_data">MySQLTableReport::process_form_data()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">Read all form data and process values. This will be called automatically  by query() and execute() methods.</div>
					</dd>
		</dl>
	<a name="q"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">q</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">query</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodquery">MySQLTableReport::query()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">generate the SQL query and return it as a string.</div>
					</dd>
		</dl>
	<a name="r"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">r</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">raw_where</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodraw_where">MySQLTableReport::raw_where()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">raw_where is an unprocessed string that is added to the WHERE clause</div>
					</dd>
		</dl>
	<a name="s"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">s</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">select</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodselect">MySQLTableReport::select()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">add a column to the select field list</div>
					</dd>
			<dt class="field">
						<span class="method-title">set_pivot_values</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodset_pivot_values">MySQLTableReport::set_pivot_values()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">pivot operations require some setup -- this defines the list of values to turn into  additional columns when we ask the report to pivot a column.</div>
					</dd>
		</dl>
	<a name="w"></a>
	<div class="index-letter-section">
		<div style="float: left" class="index-letter-title">w</div>
		<div style="float: right"><a href="#top">top</a></div>
		<div style="clear: both"></div>
	</div>
	<dl>
			<dt class="field">
						<span class="method-title">where</span>
					</dt>
		<dd class="index-item-body">
			<div class="index-item-details"><a href="MySQLTableReport/MySQLTableReport.html#methodwhere">MySQLTableReport::where()</a> in MySQLTableReport.php</div>
							<div class="index-item-description">add a condition to the WHERE clause.</div>
					</dd>
		</dl>

<div class="index-letter-menu">
	<a class="index-letter" href="elementindex_MySQLTableReport.html#c">c</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#d">d</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#e">e</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#f">f</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#g">g</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#h">h</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#j">j</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#l">l</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#m">m</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#n">n</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#o">o</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#p">p</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#q">q</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#r">r</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#s">s</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#w">w</a>
	<a class="index-letter" href="elementindex_MySQLTableReport.html#_">_</a>
</div>	</body>
</html>